﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="JobseekerAdmin.aspx.cs" Inherits="iResume.JobseekerAdmin" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
    <style type="text/css">
        .style1
        {
            width: 118px;
        }
        .style2
        {
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <table style="width:100%;">
        <tr>
            <td class="style2">
                &nbsp;</td>
            <td class="style1">
                &nbsp;</td>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td class="style2" colspan="4">
                <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
                    AutoGenerateColumns="False" CellPadding="4" DataKeyNames="emailAdd" 
                    DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None" 
                    Height="118px" Width="931px">
                    <AlternatingRowStyle BackColor="White" />
                    <Columns>
                        <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" 
                            ShowSelectButton="True" />
                        <asp:BoundField DataField="fullName" HeaderText="fullName" 
                            SortExpression="fullName" />
                        <asp:BoundField DataField="emailAdd" HeaderText="emailAdd" ReadOnly="True" 
                            SortExpression="emailAdd" />
                        <asp:BoundField DataField="category" HeaderText="category" 
                            SortExpression="category" />
                        <asp:BoundField DataField="profile" HeaderText="profile" 
                            SortExpression="profile" />
                        <asp:BoundField DataField="education" HeaderText="education" 
                            SortExpression="education" />
                        <asp:BoundField DataField="Skills" HeaderText="Skills" 
                            SortExpression="Skills" />
                        <asp:BoundField DataField="workexperience" HeaderText="workexperience" 
                            SortExpression="workexperience" />
                    </Columns>
                    <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                    <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                    <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
                    <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
                    <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
                    <SortedAscendingCellStyle BackColor="#FDF5AC" />
                    <SortedAscendingHeaderStyle BackColor="#4D0000" />
                    <SortedDescendingCellStyle BackColor="#FCF6C0" />
                    <SortedDescendingHeaderStyle BackColor="#820000" />
                </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                    ConflictDetection="CompareAllValues" 
                    ConnectionString="<%$ ConnectionStrings:iResumeConnectionString %>" 
                    DeleteCommand="DELETE FROM [JobSeeker] WHERE [emailAdd] = @original_emailAdd AND [fullName] = @original_fullName AND (([category] = @original_category) OR ([category] IS NULL AND @original_category IS NULL)) AND (([profile] = @original_profile) OR ([profile] IS NULL AND @original_profile IS NULL)) AND (([education] = @original_education) OR ([education] IS NULL AND @original_education IS NULL)) AND (([Skills] = @original_Skills) OR ([Skills] IS NULL AND @original_Skills IS NULL)) AND (([workexperience] = @original_workexperience) OR ([workexperience] IS NULL AND @original_workexperience IS NULL))" 
                    InsertCommand="INSERT INTO [JobSeeker] ([fullName], [emailAdd], [category], [profile], [education], [Skills], [workexperience]) VALUES (@fullName, @emailAdd, @category, @profile, @education, @Skills, @workexperience)" 
                    OldValuesParameterFormatString="original_{0}" 
                    SelectCommand="SELECT [fullName], [emailAdd], [category], [profile], [education], [Skills], [workexperience] FROM [JobSeeker]" 
                    UpdateCommand="UPDATE [JobSeeker] SET [fullName] = @fullName, [category] = @category, [profile] = @profile, [education] = @education, [Skills] = @Skills, [workexperience] = @workexperience WHERE [emailAdd] = @original_emailAdd AND [fullName] = @original_fullName AND (([category] = @original_category) OR ([category] IS NULL AND @original_category IS NULL)) AND (([profile] = @original_profile) OR ([profile] IS NULL AND @original_profile IS NULL)) AND (([education] = @original_education) OR ([education] IS NULL AND @original_education IS NULL)) AND (([Skills] = @original_Skills) OR ([Skills] IS NULL AND @original_Skills IS NULL)) AND (([workexperience] = @original_workexperience) OR ([workexperience] IS NULL AND @original_workexperience IS NULL))">
                    <DeleteParameters>
                        <asp:Parameter Name="original_emailAdd" Type="String" />
                        <asp:Parameter Name="original_fullName" Type="String" />
                        <asp:Parameter Name="original_category" Type="String" />
                        <asp:Parameter Name="original_profile" Type="String" />
                        <asp:Parameter Name="original_education" Type="String" />
                        <asp:Parameter Name="original_Skills" Type="String" />
                        <asp:Parameter Name="original_workexperience" Type="String" />
                    </DeleteParameters>
                    <InsertParameters>
                        <asp:Parameter Name="fullName" Type="String" />
                        <asp:Parameter Name="emailAdd" Type="String" />
                        <asp:Parameter Name="category" Type="String" />
                        <asp:Parameter Name="profile" Type="String" />
                        <asp:Parameter Name="education" Type="String" />
                        <asp:Parameter Name="Skills" Type="String" />
                        <asp:Parameter Name="workexperience" Type="String" />
                    </InsertParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="fullName" Type="String" />
                        <asp:Parameter Name="category" Type="String" />
                        <asp:Parameter Name="profile" Type="String" />
                        <asp:Parameter Name="education" Type="String" />
                        <asp:Parameter Name="Skills" Type="String" />
                        <asp:Parameter Name="workexperience" Type="String" />
                        <asp:Parameter Name="original_emailAdd" Type="String" />
                        <asp:Parameter Name="original_fullName" Type="String" />
                        <asp:Parameter Name="original_category" Type="String" />
                        <asp:Parameter Name="original_profile" Type="String" />
                        <asp:Parameter Name="original_education" Type="String" />
                        <asp:Parameter Name="original_Skills" Type="String" />
                        <asp:Parameter Name="original_workexperience" Type="String" />
                    </UpdateParameters>
                </asp:SqlDataSource>
            </td>
        </tr>
    </table>
</asp:Content>
